[Company Name] Quarterly Revenue Planning
[Date]
Gray cells are calculated for you. You do not need to enter anything in them.
[Company Name] CONFIDENTIAL
Opportunity name A. Datum Corporation Adventure Works Alpine Ski House Baldwin Museum of Science Blue Yonder Airlines City Power & Light Coho Vineyard Coho Winery Coho Vineyard & Winery Contoso, Ltd. Contoso Pharmaceuticals Consolidated Messenger Fabrikam, Inc. Fourth Coffee Graphic Design Institute Humongous Insurance Litware, Inc. Lucerne Publishing Margie's Travel Northwind Traders Proseware, Inc. School of Fine Art Southridge Video Tailspin Toys TOTAL
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Optimistic forecast 150,000 145,200 162,500 147,500 148,000 175,000 149,000 142,000 189,900 172,500 163,500 155,500 166,000 180,000 140,000 155,000 173,200 146,500 156,750 162,000 157,000 173,000 171,000 168,000 3,849,050
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Most likely forecast 120,000 122,000 120,000 125,000 140,000 150,000 125,000 131,000 175,000 156,000 146,000 150,000 133,000 170,000 120,000 135,000 168,500 142,400 152,500 142,000 143,000 165,000 161,000 146,000 3,438,400
Pessimistic forecast $ 90,000 $ 89,000 $ 84,000 $ 99,000 $ 132,000 $ 125,000 $ 101,000 $ 119,000 $ 145,000 $ 142,000 $ 123,000 $ 141,000 $ 112,000 $ 160,000 $ 100,000 $ 115,000 $ 161,900 $ 137,500 $ 145,200 $ 122,000 $ 127,000 $ 154,000 $ 151,000 $ 129,000 $ 3,004,600
Forecast close Q1 Q1 Q1 Q2 Q2 Q2 Q3 Q3 Q3 Q4 Q4 Q4 Q1 Q1 Q2 Q2 Q4 Q4 Q4 Q1 Q1 Q2 Q3 Q3
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Mean forecast 120,000 120,367 121,083 124,417 140,000 150,000 125,000 130,833 172,483 156,417 145,083 149,417 135,000 170,000 120,000 135,000 168,183 142,267 151,992 142,000 142,667 164,500 161,000 146,833 3,434,542
[Company Name] Quarterly Revenue Planning: Pessimistic Revenue
[Date]
Gray cells are calculated for you. You do not need to enter anything in them.
[Company Name] CONFIDENTIAL
Quarter 1 forecast $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 90,000 89,000 84,000 112,000 160,000 122,000 127,000 784,000 784,000 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 2 forecast 99,000 132,000 125,000 100,000 115,000 154,000 725,000 1,509,000 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 3 forecast 101,000 119,000 145,000 151,000 129,000 645,000 2,154,000 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 4 forecast 142,000 123,000 141,000 161,900 137,500 145,200 850,600 3,004,600
TOTALS Cumulative TOTALS
[Company Name] Quarterly Revenue Planning: Most Likely Revenue
[Date]
Gray cells are calculated for you. You do not need to enter anything in them.
[Company Name] CONFIDENTIAL
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 1 forecast 120,000 122,000 120,000 133,000 170,000 142,000 143,000 950,000 950,000
Quarter 2 forecast $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 125,000 140,000 150,000 120,000 135,000 165,000 835,000 1,785,000 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 3 forecast 125,000 131,000 175,000 161,000 146,000 738,000 2,523,000 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 4 forecast 156,000 146,000 150,000 168,500 142,400 152,500 915,400 3,438,400
TOTALS Cumulative TOTALS
[Company Name] Quarterly Revenue Planning: Mean Revenue
[Date]
Gray cells are calculated for you. You do not need to enter anything in them.
[Company Name] CONFIDENTIAL
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 1 forecast 120,000 120,367 121,083 135,000 170,000 142,000 142,667 951,117 951,117
Quarter 2 forecast $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 124,417 140,000 150,000 120,000 135,000 164,500 833,917 1,785,033 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 3 forecast 125,000 130,833 172,483 161,000 146,833 736,150 2,521,183 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 4 forecast 156,417 145,083 149,417 168,183 142,267 151,992 913,358 3,434,542
TOTALS Cumulative TOTALS
[Company Name] Quarterly Revenue Planning: Optimistic Revenue
[Date]
Gray cells are calculated for you. You do not need to enter anything in them.
[Company Name] CONFIDENTIAL
$ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 1 forecast 150,000 145,200 162,500 166,000 180,000 162,000 157,000 1,122,700 1,122,700
Quarter 2 forecast $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 147,500 148,000 175,000 140,000 155,000 173,000 938,500 2,061,200 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 3 forecast 149,000 142,000 189,900 171,000 168,000 819,900 2,881,100 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $
Quarter 4 forecast 172,500 163,500 155,500 173,200 146,500 156,750 967,950 3,849,050
TOTALS Cumulative TOTALS
Quarterly Revenue
$1,200,000
$1,000,000
$800,000
Revenue
$600,000
$400,000
$200,000
$Q1 Pessimistic Most Likely Mean Optimistic $784,000 $950,000 $951,117 $1,122,700 Q2 $725,000 $835,000 $833,917 $938,500 Q3 $645,000 $738,000 $736,150 $819,900 Q4 $850,600 $915,400 $913,358 $967,950
Quarter
Cumulative Revenue
$4,500,000 $4,000,000 $3,500,000 $3,000,000
Revenue
$2,500,000 $2,000,000 $1,500,000 $1,000,000 $500,000 $Q1 Pessimistic Most Likely Mean Optimistic $784,000 $950,000 $951,117 $1,122,700 Q2 $1,509,000 $1,785,000 $1,785,033 $2,061,200 Q3 $2,154,000 $2,523,000 $2,521,183 $2,881,100 Q4 $3,004,600 $3,438,400 $3,434,542 $3,849,050
Quarter